import datetime
from applications.extensions import db


class Device_broken(db.Model):
    __tablename__ = 'device_broken'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment="ID")
    deviceName = db.Column(db.String(20), comment="设备名称")
    deviceId = db.Column(db.Integer, comment="设备ID")
    producer = db.Column(db.String(50), comment="生产厂家")
    warranty = db.Column(db.String(255), comment="保修期")
    detail = db.Column(db.String(255), comment="详细信息")
    create_at = db.Column(db.DateTime, default=datetime.datetime.now, comment='创建时间')
